package io.renren.utils;

import io.renren.entity.ColumnEntity;
import io.renren.entity.TableEntity;
import org.apache.commons.configuration.Configuration;
import org.apache.commons.configuration.ConfigurationException;
import org.apache.commons.configuration.PropertiesConfiguration;
import org.apache.commons.io.IOUtils;
import org.apache.commons.lang.CharUtils;
import org.apache.commons.lang.StringUtils;
import org.apache.commons.lang.WordUtils;
import org.apache.velocity.Template;
import org.apache.velocity.VelocityContext;
import org.apache.velocity.app.Velocity;

import java.io.File;
import java.io.IOException;
import java.io.StringWriter;
import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import java.util.Properties;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.zip.ZipEntry;
import java.util.zip.ZipOutputStream;

/**
 * 代码生成器   工具类
 *
 * @author chenshun
 * @email sunlightcs@gmail.com
 * @date 2016年12月19日 下午11:40:24
 */
public class GenUtils {

    public static List<String> getTemplates() {
        List<String> templates = new ArrayList<String>();
        templates.add("template/Entity.java.vm");
        templates.add("template/Dao.java.vm");
        templates.add("template/Dao.xml.vm");
        templates.add("template/Service.java.vm");
        templates.add("template/ServiceImpl.java.vm");
        templates.add("template/Controller.java.vm");
        templates.add("template/list.html.vm");
        templates.add("template/list.js.vm");
        templates.add("template/menu.sql.vm");

        //dzka
        templates.add("template/Po.java.vm");
        templates.add("template/po.hbm.xml.vm");
        templates.add("template/PoDao.java.vm");
        templates.add("template/PoDaoImpl.java.vm");
        return templates;
    }

    /**
     * 生成代码
     */
    public static void generatorCode(Map<String, String> table,
                                     List<Map<String, Object>> columns, ZipOutputStream zip) {
        //配置信息
        Configuration config = getConfig();
        boolean hasBigDecimal = false;
        //表信息
        TableEntity tableEntity = new TableEntity();
        tableEntity.setTableName(table.get("tableName"));
        if (StringUtils.isNotBlank(table.get("tableComment"))) {
            tableEntity.setComments(table.get("tableComment"));
        } else {
            tableEntity.setComments("error：请输入表的注释");
        }

        //表名转换成Java类名
        String className = tableToJava(tableEntity.getTableName(), config.getString("tablePrefix"));
        tableEntity.setClassName(className);
        tableEntity.setClassname(StringUtils.uncapitalize(className));

        //列信息
        List<ColumnEntity> columsList = new ArrayList<>();
        for (Map<String, Object> column : columns) {
            ColumnEntity columnEntity = new ColumnEntity();
            columnEntity.setColumnName((String) column.get("columnName"));//列名
            columnEntity.setDataType((String) column.get("dataType"));//列类型
            columnEntity.setComments((String) column.get("columnComment"));//列注释
            columnEntity.setExtra((String) column.get("extra"));//auto-increament

            //列名转换成Java属性名
            String attrName = columnToJava(columnEntity.getColumnName());
            columnEntity.setAttrName(attrName);
            columnEntity.setAttrname(StringUtils.uncapitalize(attrName));

            //列名转换成大写数据库字段名
            columnEntity.setDbAttrName(GenUtils.switchParam(attrName));

            //列长度
            if (column.get("dataLength") != null) {
                columnEntity.setDataLength(Integer.parseInt(((BigDecimal) column.get("dataLength")).toString()));
            }

            //列的数据类型，转换成Java类型
            if (columnEntity.getDataType().equals(Constant.NUMBER)) {//如果列类型为NUMBER类型

                /** number(precision, scale) */
                if (column.get("dataPrecision") != null) {
                    Integer dataPrecision = Integer.parseInt(((BigDecimal) column.get("dataPrecision")).toString());
                    columnEntity.setDataPrecision(dataPrecision);//列精度
                    //columnEntity.setDataLength(dataPrecision);//设置data_length为data_precision精度

                    //列dataPrecision长度（1~9）--> Integer
                    if (dataPrecision <= 9) {
                        columnEntity.setDataType(Constant.NUMBER_INTEGER);
                    }
                    //列dataPrecision长度（10~18）--> Long
                    if (dataPrecision <= 18 && dataPrecision >= 10) {
                        columnEntity.setDataType(Constant.NUMBER_LONG);
                    }
                    //TODO 暂时用不到，默认为Long类型
                    //列dataPrecision长度（18+）--> BigDecimal
                    /*if (dataPrecision > 18) {
                        columnEntity.setDataType(Constant.NUMBER_BIGDECIMAL);
                    }*/
                } else {
                    columnEntity.setDataPrecision(columnEntity.getDataLength());//为主键设置的
                }

                //判断是Double类型必须放在最后
                if (column.get("dataScale") != null) {
                    Integer dataScale = Integer.parseInt(((BigDecimal) column.get("dataScale")).toString());
                    if (!dataScale.equals(0)) {//data_scale长度不等于0
                        columnEntity.setDataScale(dataScale);//列规模
                        columnEntity.setDataType(Constant.NUMBER_DOUBLE);
                    } else {
                        columnEntity.setDataScale(0);
                    }
                } else {//为主键设置的
                    columnEntity.setDataScale(0);//为主键设置的
                }
            }
            String attrType = config.getString(columnEntity.getDataType(), "unknowType");
            columnEntity.setAttrType(attrType);
            if (!hasBigDecimal && attrType.equals("BigDecimal")) {
                hasBigDecimal = true;
            }
            //是否主键
            if ("PRI".equalsIgnoreCase((String) column.get("columnKey")) && tableEntity.getPk() == null) {
                tableEntity.setPk(columnEntity);
            }

            columsList.add(columnEntity);
        }
        tableEntity.setColumns(columsList);

        //没主键，则第一个字段为主键
        if (tableEntity.getPk() == null) {
            tableEntity.setPk(tableEntity.getColumns().get(0));
        }

        //设置velocity资源加载器
        Properties prop = new Properties();
        prop.put("file.resource.loader.class", "org.apache.velocity.runtime.resource.loader.ClasspathResourceLoader");
        Velocity.init(prop);
        String mainPath = config.getString("mainPath");
        mainPath = StringUtils.isBlank(mainPath) ? "io.renren" : mainPath;
        //封装模板数据
        Map<String, Object> map = new HashMap<>();
        map.put("tableName", tableEntity.getTableName());
        map.put("comments", tableEntity.getComments());
        map.put("pk", tableEntity.getPk());
        map.put("className", tableEntity.getClassName());
        map.put("classname", tableEntity.getClassname());
        map.put("pathName", tableEntity.getClassname().toLowerCase());
        map.put("columns", tableEntity.getColumns());
        map.put("hasBigDecimal", hasBigDecimal);
        map.put("mainPath", mainPath);
        map.put("package", config.getString("package"));
        map.put("moduleName", config.getString("moduleName"));
        map.put("author", config.getString("author"));
        map.put("email", config.getString("email"));
        map.put("datetime", DateUtils.format(new Date(), DateUtils.DATE_TIME_PATTERN));
        VelocityContext context = new VelocityContext(map);

        //获取模板列表
        List<String> templates = getTemplates();
        for (String template : templates) {
            //渲染模板
            StringWriter sw = new StringWriter();
            Template tpl = Velocity.getTemplate(template, "UTF-8");
            tpl.merge(context, sw);

            try {
                String flag = getFileName(template, tableEntity.getClassName(), config.getString("package"), config.getString("moduleName"));
                //添加到zip
                if (StringUtils.isBlank(flag)) {
                    continue;
                }
                zip.putNextEntry(new ZipEntry(flag));
                IOUtils.write(sw.toString(), zip, "UTF-8");
                IOUtils.closeQuietly(sw);
                zip.closeEntry();
            } catch (IOException e) {
                throw new RRException("渲染模板失败，表名：" + tableEntity.getTableName(), e);
            }
        }
    }


    /**
     * 列名转换成Java属性名
     */
    public static String columnToJava(String columnName) {
        return WordUtils.capitalizeFully(columnName, new char[]{'_'}).replace("_", "");
    }

    /**
     * 表名转换成Java类名
     */
    public static String tableToJava(String tableName, String tablePrefix) {
        String[] tablePrefixs = tablePrefix.split("\\|");
        for (String tabPre : tablePrefixs) {
            if (StringUtils.isNotBlank(tabPre)) {
                tableName = tableName.replace(tabPre, "");
            }
        }
        return columnToJava(tableName);
    }

    /**
     * 获取配置信息
     */
    public static Configuration getConfig() {
        try {
            return new PropertiesConfiguration("generator.properties");
        } catch (ConfigurationException e) {
            throw new RRException("获取配置文件失败，", e);
        }
    }

    /**
     * 获取文件名
     */
    public static String getFileName(String template, String className, String packageName, String moduleName) {
        /*
        String packagePath = "main" + File.separator + "java" + File.separator;
        if (StringUtils.isNotBlank(packageName)) {
            packagePath += packageName.replace(".", File.separator) + File.separator + moduleName + File.separator;
        }

        if (template.contains("Entity.java.vm")) {
            return packagePath + "entity" + File.separator + className + "Entity.java";
        }

        if (template.contains("Dao.java.vm")) {
            return packagePath + "dao" + File.separator + className + "Dao.java";
        }

        if (template.contains("Service.java.vm")) {
            return packagePath + "service" + File.separator + className + "Service.java";
        }

        if (template.contains("ServiceImpl.java.vm")) {
            return packagePath + "service" + File.separator + "impl" + File.separator + className + "ServiceImpl.java";
        }

        if (template.contains("Controller.java.vm")) {
            return packagePath + "controller" + File.separator + className + "Controller.java";
        }

        if (template.contains("Dao.xml.vm")) {
            return "main" + File.separator + "resources" + File.separator + "mapper" + File.separator + moduleName + File.separator + className + "Dao.xml";
        }

        if (template.contains("list.html.vm")) {
            return "main" + File.separator + "resources" + File.separator + "views" + File.separator
                    + "modules" + File.separator + moduleName + File.separator + className.toLowerCase() + ".html";
        }

        if (template.contains("list.js.vm")) {
            return "main" + File.separator + "resources" + File.separator + "static" + File.separator + "js" + File.separator
                    + "modules" + File.separator + moduleName + File.separator + className.toLowerCase() + ".js";
        }

        if (template.contains("menu.sql.vm")) {
            return className.toLowerCase() + "_menu.sql";
        }
        */

        /** 生成StudentPo.java */
        if (template.contains("Po.java.vm")) {
            return className + "Po.java";
        }
        /** 生成StudentPo.hbm.xml */
        if (template.contains("po.hbm.xml.vm")) {
            return className + "Po.hbm.xml";
        }
        /** 生成StudentPoDao.java */
        if (template.contains("PoDao.java.vm")) {
            return className + "PoDao.java";
        }
        /** 生成StudentPoDaoImpl.java */
        if (template.contains("PoDaoImpl.java.vm")) {
            return className + "PoDaoImpl.java";
        }
        return null;
    }

    /**
     * 对象属性转换为字段  例如：userName to user_name
     *
     * @param property 字段名
     * @return
     */
    public static String propertyToField(String property) {
        if (null == property) {
            return "";
        }
        char[] chars = property.toCharArray();
        StringBuffer sb = new StringBuffer();
        for (char c : chars) {
            if (CharUtils.isAsciiAlphaUpper(c)) {
                sb.append("_" + StringUtils.lowerCase(CharUtils.toString(c)));
            } else {
                sb.append(c);
            }
        }
        return sb.toString();
    }

    /**
     * 属性名转换成数据库字段名
     *
     * @param name 属性名称
     * @return String
     */
    public static String switchParam(String name) {
        if (name.matches("[a-z]+[A-Z][a-z]+([A-Z][a-z]+)*")) {
            Pattern pattern = Pattern.compile("[A-Z]");
            Matcher matcher = pattern.matcher(name);
            while (matcher.find()) {
                String old = matcher.group();
                String ne = matcher.group().toLowerCase();
                name = name.replaceAll(old, "_" + ne);
            }
            name = name.toUpperCase();
        }
        return name;
    }
}
